EMT Practice Test

1. Question Content...

---

Question1: Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing. UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing "lock errors" consistently.
What should a data architect recommend to mitigate these errors?

Question2: Universal Containers (UC) wants to ensure their data on 100,000 Accounts pertaining mostly to US-based companies is enriched and cleansed on an ongoing basis. UC is looking for a solution that allows easy monitoring of key data quality metrics. What should be the recommended solution to meet this requirement?

Question3: NTO (Northern Trail Outlets) has a complex Salesforce org which has been developed over past 5 years.
Internal users are complaining abt multiple data issues, including incomplete and duplicate data in the org.
NTO has decided to engage a data architect to analyze and define data quality standards.
Which 3 key factors should a data architect consider while defining data quality standards? Choose 3 answers:

Question4: Managers at Universal Containers (UC) have noticed that shipment records (a custom object) are being sent to the shipping department with bad address data Specifically, addresses have missing data like City and poorly formatted Postal codes. Which two approaches will solve this issue? Choose 2 answers

Question5: UC has one SF org (Org A) and recently acquired a secondary company with its own Salesforce org (Org B). UC has decided to keep the orgs running separately but would like to bidirectionally share opportunities between the orgs in near-real time.
Which 3 options should a data architect recommend to share data between Org A and Org B?
Choose 3 answers.

Question6: Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain ""key"" fields which are important to their sales reps.
What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency? (Choose two.)

Question7: What 2 data management policies does the data classification feature allow customers to classify in salesforce? Choose 2 answers:

Question8: Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application.
Which two methods should be recommended to meet this requirement? Choose 2 answers

Question9: Get Cloudy Consulting is migrating their legacy system's users and data to Salesforce. They will be creating
15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.
Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.
Which two approaches will accomplish this goal? (Choose two.)

Question10: NTO has been using salesforce for sales and service for 10 years. For the past 2 years, the marketing group has noticed a raise from 0 to 35 % in returned mail when sending mail using the contact information stored in salesforce.
Which solution should the data architect use to reduce the amount of returned mails?

Question11: Universal Containers wishes to send data from Salesforce to an external system to generate invoices from their Order Management System (OMS). They want a Salesforce administrator to be able to customize which fields be sent to the external system without modifying code. What two approaches should an architect recommend to deliver the desired solution? Choose 2 answers

Question12: Universal container (UC) would like to build a Human resources application on Salesforce to manage employee details, payroll, and hiring efforts. To adequately and store the relevant data, the application will need to leverage 45 custom objects. In addition to this, UC expects roughly 20,00 API calls into Salesfoce from an n-premises application daily.
Which license type should a data architect recommend that best fits these requirements?

Question13: DreamHouse Realty has a Salesforce org that is used to manage Contacts.
What are two things an Architect should consider using to maintain data quality in this situation? (Choose two.)

Question14: A data architect has been tasked with optimizing a data stewardship engagement for a Salesforce instance Which three areas of Salesforce should the architect review before proposing any design recommendation? Choose 3 answers

Question15: Universal Containers (CU) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW.
What data extraction strategy should a data architect use for maximum performance?

Question16: Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system. Which two options should be recommended to make this report perform well and satisfy the business need?

Question17: Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Saiesforce Is implemented as follows:
1. Sales users enter their opportunities in Salesforce for forecasting and reporting purposes.
2. NTO has a product pricing system (PPS) that is used to update the Opportunity Amount field on opportunities on a daily basis.
3. PPS is the trusted source within NTO for Opportunity Amount.
4. NTO uses Opportunity Forecast for its sales planning and management.
Sales users have noticed that their updates to the Opportunity Amount field are overwritten when PPS updates their opportunities.
How should a data architect address this overwriting issue?

Question18: A customer has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout. The customer has noticed that many of the records coming from the external system are missing data in this field. What two things should the architect do to ensure this field always contains data coming from the source system? Choose 2 answers

Question19: Cloud Kicks needs to optimize data stewardship engagement for a Salesforce instance.
Before proposing design recommendations, the Data Architect is first assessing relevant areas of Salesforce.
Which three areas are appropriate to assess? (Choose three.)

Question20: UC has a requirement to migrate 100 million order records from a legacy ERP application into the salesforce platform. UC does not have any requirements around reporting on the migrated data.
What should a data architect recommend to reduce the performance degradation of the platform?

Question21: UC needs to load a large volume of leads into salesforce on a weekly basis. During this process the validation rules are disabled.
What should a data architect recommend to ensure data quality is maintained in salesforce.

Question22: Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage.
Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?

Question23: Universal Containers (UC) has a complex system landscape and is implementing a data governance program for the first time Which two first steps would be appropriate for UC to initiate an assessment of data architecture? Choose 2 answers

Question24: Universal Containers is implementing Sales Cloud for patient management and would like to encrypt sensitive patient records being stored in files.
Which solution should a data architect recommend to solve this requirement?

Question25: NTO has multiple systems across its enterprise landscape including salesforce, with disparate version the customer records.
In salesforce, the customer is represented by the contact object.
NTO utilizes an MDM solution with these attributes:
1. The MDM solution keeps track of customer master with a master key.
2. The master key is a map to the record ID's from each external system that customer data is stored within.
3. The MDM solution provides de-duplication features, so it acts as the single source of truth.
How should a data architect implement the storage of master key within salesforce?

Question26: An architect is planning on having different batches to load one million Opportunities into Salesforce using the Bulk API in parallel mode. What should be considered when loading the Opportunity records?

Question27: Get Cloudy Consulting is migrating their legacy system's users and data to Salesforce. They will be creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.
Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.
Which two approaches will accomplish this goal? (Choose two.)

Question28: Universal Containers has a public website with several forms that create Lead records in Salesforce using the REST API. When designing these forms, which two techniques will help maintain a high level of data quality?

Question29: UC has a roll-up summary field on Account to calculate the count of contacts associated with an account. During the account load, SF is throwing an "Unable to lock a row" error.
Which solution should a data architect recommend, to resolve the error?

Question30: Cloud Kicks has a Salesforce instance with 12,000 Account records. Managers at the company have noticed similar, but not identical, Account names and addresses.
The Chief Technology Officer (CTO) at Cloud Kicks is concerned about proper data quality.
Which steps should the CTO take to address this issue?

Question31: Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect
1. The data model for Org B will drastically change with different objects, fields, and picklist values.
2. Three million records will need to be migrated from org A to org B for compliance reasons.
3. The migrate will need occur within the next two month, prior to be split.
Which migrate strategy should a data architect use to successfully migrate the date?

Question32: DreamHouse Realty has a data model as shown in the image. The Project object has a private sharing model, and it has Roll-Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project.
There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.

What should the Architect consider in this situation?

Question33: Universal Containers (UC) is implementing a new customer categorization process where customers should be assigned to a Gold, Silver, or Bronze category if they've purchased UC's new support service. Customers are expected to be evenly distributed across all three categories. Currently, UC has around 500,000 customers, and is expecting 1% of existing non-categorized customers to purchase UC's new support service every month over the next five years. What is the recommended solution to ensure long-term performance, bearing in mind the above requirements?

Question34: UC is planning a massive SF implementation with large volumes of data. As part of the org's implementation, several roles, territories, groups, and sharing rules have been configured. The data architect has been tasked with loading all of the required data, including user data, in a timely manner.
What should a data architect do to minimize data load times due to system calculations?

Question35: Universal Containers (UC) needs to run monthly and yearly reports on opportunities and orders for sales reporting. There are 5 million opportunities and 10 million orders. Sales users are complaining that the report will regularly timeout.
What is the fastest and most effective way for a data architect to solve the time-out issue?

Question36: Universal Containers (UC) is launching an RFP to acquire a new accounting product available on AppExchange. UC is expecting to issue 5 million invoices per year, with each invoice containing an average of 10 line items. What should UC's Data Architect recommend to ensure scalability?

Question37: DreamHouse Realty has a legacy system that captures Branch Offices and Transactions. DreamHouse Realty has 15 Branch Offices. Transactions can relate to any Branch Office. DreamHouse Realty has created hundreds of thousands of Transactions per year.
A Data Architect needs to denormalize this data model into a single Transaction object with a Branch Office picklist.
What are two important considerations for the Data Architect in this scenario? (Choose two.)

Question38: Universal Containers (UC) has implemented Salesforce, UC is running out of storage and needs to have an archiving solution, UC would like to maintain two years of data in Saleforce and archive older data out of Salesforce.
Which solution should a data architect recommend as an archiving solution?

Question39: Universal Container require all customers to provide either a phone number of an email address when registering for an account.
What should the data architect use to ensure this requirement is met?

Question40: UC has been using SF for 10 years. Lately, users have noticed, that the pages load slowly when viewing Customer and Account list view.
To mitigate, UC will implement a data archive strategy to reduce the amount of data actively loaded.
Which 2 tasks are required to define the strategy? Choose 2 answers:

Question41: NTO has a loyalty program to reward repeat customers. The following conditions exists:
1. Reward levels are earned based on the amount spent during the previous 12 months.
2. The program will track every item a customer has bought and grant them points for discount.
3. The program generates 100 million records each month.
NTO customer support would like to see a summary of a customer's recent transaction and reward level(s) they have attained.
Which solution should the data architect use to provide the information within the salesforce for the customer support agents?

Question42: A customer is operating in a highly reputated industry and is planning to implement SF. The customer information maintained in SF, includes the following:
Personally, identifiable information (PII)
IP restrictions on profiles organized by Geographic location
Financial records that need to be private and accessible only by the assigned Sales associate.
User should not be allowed to export information from Salesforce.
Enterprise security has mandate access to be restricted to users within a specific geography and detail monitoring of user activity. Which 3 Salesforce shield capabilities should a data architect recommend? Choose 3 answers:

Question43: A large insurance provider is looking to implement Salesforce. The following exist.
1. Multiple channel for lead acquisition
2. Duplication leads across channels
3. Poor customer experience and higher costs
On analysis, it found that there are duplicate leads that are resulting to mitigate the issues?

Question44: UC is using SF CRM. UC sales managers are complaining about data quality and would like to monitor and measure data quality.
Which 2 solutions should a data architect recommend to monitor and measure data quality?
Choose 2 answers.

Question45: Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org.
Which three recommendations should a data architect make is order to reduce the number of records from the org?
Choose 3 answers

Question46: Universal Containers (UC) is implementing its new Internet of Things technology, which consists of smart containers that provide information on container temperature and humidity updated every 10 minutes back to UC. There are roughly 10,000 containers equipped with this technology with the number expected to increase to 50,000 across the next five years. It is essential that Salesforce user have access to current and historical temperature and humidity data for each container. What is the recommended solution?

Question47: Universal Containers (UC) recently migrated 1 billion customer related records from a legacy datastore to Heroku Postgres. A subnet of the data needs to be synchronized with Salesforce so that service agents are able to support customers directly within the service console. The remaining non-synchronized set of data will need to be accessed by Salesforce at any point in time, but UC management is concerned about storage limitations.
What should a data architect recommend to meet these requirements with minimal effort?

Question48: A large retail B2C customer wants to build a 360-degree view of its customers for its call center agents. The customer information is currently maintained in the following systems:
1. Salesforce CRM
2. Custom billing solution
3. Customer master data management (MDM)
4. Contract management system
5. Marketing solution
What should a data architect recommend that would help uniquely identify the customer across multiple systems?

Question49: Universal Containers (UC) requires 2 years of customer related cases to be available on SF for operational reporting. Any cases older than 2 years and upto 7 years need to be available on demand to the Service agents. UC creates 5 million cases per yr.
Which 2 data archiving strategies should a data architect recommend? Choose 2 options:

Question50: Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicate customer accounts, contacts, and leads. UC wants to fix this issue immediately by prompting users about a record that possibly exists in Salesforce. UC wants a report regarding duplicate records. What would be the recommended approach to help UC start immediately?

Question51: DreamHouse Realty has a data model as shown in the image. The Project object has a private sharing model, and it has Roll-Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project.
There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.

Question52: Company S was recently acquired by Company
T. As part of the acquisition, all of the data for the Company S's Salesforce instance (source) must be migrated into the Company T's Salesforce instance (target). Company S has 6 million Case records.
An Architect has been tasked with optimizing the data load time.
What should the Architect consider to achieve this goal?

Question53: NTO has implemented salesforce for its sales users. The opportunity management in salesforce is implemented as follows:
1. Sales users enter their opportunities in salesforce for forecasting and reporting purposes.
2. NTO has a product pricing system (PPS) that is used to update opportunity amount field on opportunities on a daily basis.
3. PPS is the trusted source within the NTO for opportunity amount.
4. NTO uses opportunity forecast for its sales planning and management.
Sales users have noticed that their updates to the opportunity amount field are overwritten when PPS updates their opportunities.
How should a data architect address this overriding issue?

Question54: Universal Containers is using Salesforce for Opportunity management and enterprise resource planning (ERP) for order management. Sales reps do not have access to the ERP and have no visibility into order status.
What solution should a data architect recommend to give the sales team visibility into order status?

Question55: DreamHouse Realty has a data model as shown in the image. The Project object has a private sharing model, and it has Roll-Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project.
There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.

Question56: What are two key artifacts used to document the data architecture for a multi -system enterprise Salesforce implementation? Choose 2 answers

Question57: Cloud Kicks has a system environment that is complex, and they plan on creating a data governance program for the first time.
What are two initial actions Cloud Kicks should take to initiate an assessment of data architecture?
(Choose two.)

Question58: Cloud Kicks has the following requirements:
- Data needs to be sent from Salesforce to an external system to generate invoices from their Order Management System (OMS).
- A Salesforce administrator must be able to customize which fields will be sent to the external system without changing code.
What are two approaches for fulfilling these requirements? (Choose two.)

Question59: US is implementing salesforce and will be using salesforce to track customer complaints, provide white papers on products and provide subscription (Fee) - based support.
Which license type will US users need to fulfil US's requirements?

Question60: Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs change of encountering race condition on the same record.
What should a data architect recommend to guarantee that records are not being updated at the same time?

Question61: Every year, Ursa Major Solar has more than 1 million orders. Each order contains an average of 10 line items. The Chief Executive Officer (CEO) needs the Sales Reps to see how much money each customer generates year-over-year. However, data storage is running low in Salesforce.
Which approach for data archiving is appropriate for this scenario?

Question62: What should a data architect do to provide additional guidance for users when they enter information in a standard field?

Question63: Get Cloud Consulting needs to integrate two different systems with customer records into the Salesforce Account object. So that no duplicate records are created in Salesforce, Master Data Management will be used.
An Architect needs to determine which system is the system of record on a field level.
What should the Architect do to achieve this goal?

Question64: DreamHouse Realty uses Custom Metadata Types instead of Custom setting.
What is an advantage of this decision?

Question65: Universal Containers has more than 10 million records in the Order _c object. The query has timed out when running a bulk query. What should be considered to resolve query timeout?

Question66: Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers

Question67: Northern Trail outfitters in migrating to salesforce from a legacy CRM system that identifies the agent relationships in a look-up table.
What should the data architect do in order to migrate the data to Salesfoce?

Question68: Universal containers is implementing Salesforce lead management. UC Procure lead data from multiple sources and would like to make sure lead data as company profile and location information. Which solution should a data architect recommend to make sure lead data has both profile and location information? Option

Question69: Cloud Kicks currently has a Public Read/Write sharing model for the company's Contacts. Cloud Kicks management team requests that only the owner of a contact record be allowed to delete that contact.
What should an Architect do to meet these requirements?

Question70: Global Containers (GC) just acquired Universal Containers (UC). Both companies use Salesforce. and as part of the acquisition, all of the data for the UC Salesforce instance (source) must be migrated into the GC Salesforce instance (target). Universal Containers has over 5 million Case records. What should the architect consider when trying to optimize the data load time?

Question71: Cloud Kicks often uses Data Loader to upsert Contact records into Salesforce to avoid creating duplicate Contacts.
Which is a common error to be aware of when using upsert?

Question72: Two million Opportunities need to be loaded in different batches into Salesforce using the Bulk API in parallel mode.
What should an Architect consider when loading the Opportunity records?

Question73: UC has millions of Cases and are running out of storage. Some user groups need to have access to historical cases for up to 7 years.
Which 2 solutions should a data architect recommend in order to minimize performance and storage issues?
Choose 2 answers:

Question74: UC has a roll-up summary field on Account to calculate the count of contacts associated with an account. During the account load, SF is throwing an "Unable to lock a row" error.
Which solution should a data architect recommend, to resolve the error?

Question75: Universal Containers (UC) is planning to move away from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system. How should an Architect design the data migration solution to meet this requirement?

Question76: Universal Containers (UC) is a business that works directly with individual consumers (B2C). They are moving from a current home-grown CRM system to Salesforce. UC has about one million consumer records.
What should the architect recommend for optimal use of Salesforce functionality and also to avoid data loading issues?

Question77: Universal Container has implemented Sales Cloud to manage patient and related health records. During a recent security audit of the system it was discovered that same standard and custom fields need to encrypted.
Which solution should a data architect recommend to encrypt existing fields?

Question78: Company S was recently acquired by Company T.
As part of the acquisition, all of the data for the Company S's Salesforce instance (source) must be migrated into the Company T's Salesforce instance (target). Company S has 6 million Case records.
An Architect has been tasked with optimizing the data load time.
What should the Architect consider to achieve this goal?

Question79: Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless of who owns the contact. However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met?

Question80: A customer wants to maintain geographic location information including latitude and longitude in a custom object. What would a data architect recommend to satisfy this requirement?

Question81: NTO has outgrown its current salesforce org and will be migrating to new org shortly. As part of this process NTO will be migrating all of its metadata and dat a. NTO's data model in the source org has a complex relationship hierarchy with several master detail and lookup relationships across objects, which should be maintained in target org.
What 3 things should a data architect do to maintain the relationship hierarchy during migration?
Choose 3 answers:

Question82: Universal Containers wants to implement a data -quality process to monitor the data that users are manually entering into the system through the Salesforce UI. Which approach should the architect recommend?

Question83: A business that works directly with individual consumers (B2C) currently has a home-grown CRM system, but they are moving to Salesforce. The business has 1.2 million consumer records and wants assistance with achieving optimal use of Salesforce functionality while also avoiding data loading issues.
What should an Architect recommend?

Question84: The data architect for UC has written a SOQL query that will return all records from the Task object that do not have a value in the WhatId field:
Select id, description, Subject from Task where WhatId != NULL
When the data architect usages the query to select values for a process a time out error occurs.
What does the data architect need to change to make this query more performant?

Question85: To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?

Question86: Ursa Major Solar is performance testing a Lightning Platform application.
Which two statements are true about this testing? (Choose two.)

Question87: A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:
1. State in which the customer is located
2. City in which the customer is located if available
3. Zip code in which the customer is located if available
4. Changes to this information should have minimum code change
What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?

Question88: Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement?
Choose 2 answers

Question89: What is an advantage of using Custom metadata type over Custom setting?

Question90: UC migrating 100,000 Accounts from an enterprise resource planning (ERP) to salesforce and is concerned about ownership skew and performance.
Which 3 recommendations should a data architect provide to prevent ownership skew?
Choose 3 answers:

Question91: Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records. What should the architect recommend to reduce data load processing time?

Question92: Universal Containers (UC) wants to assess the completeness and consistency of contact information in Salesforce. They are finding that their sales reps in many caes do not have enough information about their accounts and contacts. Also, in many cases they are not able to interpret the information in a consistent manner. They have identified certain "key" fields which are important to their sales reps. Which two steps can UC implement to assess their data for completeness and consistency?

Question93: Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless of who owns the contact.
However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met?

Question94: DreamHouse Realty has a Salesforce deployment that manages Sales, Support, and Marketing efforts in a multi-system ERP environment. The company recently reached the limits of native reports and dashboards and needs options for providing more analytical insights.
What are two approaches an Architect should recommend? (Choose two.)

Question95: Get Cloudy Consulting monitors 15,000 servers, and these servers automatically record their status every 10 minutes. Because of company policy, these status reports must be maintained for 5 years. Managers at Get Cloudy Consulting need access to up to one week's worth of these status reports with all of their details.
An Architect is recommending what data should be integrated into Salesforce and for how long it should be stored in Salesforce.
Which two limits should the Architect be aware of? (Choose two.)

Question96: Universal Containers (UC) is using Salesforce Sales & Service Cloud for B2C sales and customer service but they are experiencing a lot of duplicate customers in the system.
Which are two recommended approaches for UC to avoid duplicate data and increase the level of data quality?

Question97: Universal Containers (UC) is implementing its new Internet of Things technology, which consists of smart containers that provide information on container temperature and humidity updated every 10 minutes back to UC. There are roughly 10,000 containers equipped with this technology with the number expected to increase to 50,000 across the next five years. It is essential that Salesforce user have access to current and historical temperature and humidity data for each container. What is the recommended solution?

Question98: Northern Trail Outfitters is migrating to Salesforce from a legacy CRM system that identifies the agent relationships in a look-up table.
What should the data architect do in order to migrate the data to Salesforce?

Question99: Universal Containers (UC) wants to store product data in Salesforce, but the standard Product object does not support the more complex hierarchical structure which is currently being used in the product master system.
How can UC modify the standard Product object model to support a hierarchical data structure in order to synchronize product data from the source system to Salesforce?

Question100: Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Salesforce is implemented as follows:
1. Sales users enter their opportunities in Salesforce for forecasting and reporting purposes.
2. NTO has a product pricing system (PPS) that is used to update Opportunity Amount field on opportunities on a daily basis.
3. PPS is the trusted source within NTO for Opportunity Amount.
4. NTO uses Opportunity Forecast for its sales planning and management.
Sales users have noticed that their updates to the Opportunity Amount field are overwritten when PPS updates their opportunities.
How should a data architect address this overwriting issue?

Question101: UC has multiple SF orgs that are distributed across regional branches. Each branch stores local customer data inside its org's Account and Contact objects. This creates a scenario where UC is unable to view customers across all orgs.
UC has an initiative to create a 360-degree view of the customer, as UC would like to see Account and Contact data from all orgs in one place.
What should a data architect suggest to achieve this 360-degree view of the customer?

Question102: Get Cloudy Consulting is migrating their legacy system's users and data to Salesforce. They will be creating
15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.
Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.
Which two approaches will accomplish this goal? (Choose two.)

Question103: UC has a salesforce org with multiple automated processes defined for group membership process. UC also have multiple admins on staff that perform manual adjustments to the role hierarchy. The automated task and manual task overlap daily and UC is experiencing "Lock errors" consistently.
What should a data architect recommend mitigate these errors?

Question104: A customer wants to maintain geographic location information including latitude and longitude in a custom object. What would a data architect recommend to satisfy this requirement?

Question105: Universal Containers (UC) has a data model as shown in the image.
The Project object has a private sharing model, and it has Roll -Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com?

Question106: A company has 12 million records, and a nightly integration queries these records.
Which two areas should a Data Architect investigate during troubleshooting if queries are timing out?
(Choose two.)

Question107: Which two best practices should be followed when using SOSL for searching?

Question108: US has released a new disaster recovery (DR)policy that states that cloud solutions need a business continuity plan in place separate from the cloud providers built in data recovery solution.
Which solution should a data architect use to comply with the DR policy?

Question109: Universal Containers is integrating a new Opportunity engagement system with Salesforce.
According to their Master Data Management strategy, Salesforce is the system of record for Account, Contact, and Opportunity data. However, there does seem to be valuable Opportunity data in the new system that potentially conflicts with what is stored in Salesforce. What is the recommended course of action to appropriately integrate this new system?

Question110: UC has a variety of systems across its technology landscape, including SF, legacy enterprise resource planning (ERP) applications and homegrown CRM tools. UC has decided that they would like to consolidate all customer, opportunity and order data into Salesforce as part of its master data management (MDM) strategy.
What are the 3 key steps that a data architect should take when merging data from multiple systems into Salesforce? Choose 3 answers:

Question111: Universal Containers uses Salesforce to track its sales opportunities The Sales VP would like to better understand key relevant performance figures and help the Sales Managers take corrective actions where appropriate. What reporting option should be considered?

Question112: Universal containers is implementing Salesforce lead management. UC Precure lead data from multiple sources and would like to make sure lead data as company profile and location information. Which solution should a data architect recommend to make sure lead data has both profile and location information? Option

Question113: Universal Containers is creating a new B2C service offering for consumers to ship goods across continents. This is in addition to their well-established B2B offering. Their current Salesforce org uses the standard Account object to track B2B customers. They are expecting to have over 50,000,000 consumers over the next five years across their 50 business regions. B2C customers will be individuals. Household data is not required to be stored. What is the recommended data model for consumer account data to be stored in Salesforce?

Question114: Universal Containers is migrating their legacy system's users and data to Salesforce. They will be creating 10,000 users,2 million Account records, and 10 million Invoice records. The visibility of these records is controlled by a few dozen owner and criteria -based sharing rules. What are two approaches that will minimize data loading time during this migration to a new organization? Choose 2 answers

Question115: United Containers (UC) has released a new disaster recovery (DR) policy that states that cloud solutions need a business continuity plan in place separate from the cloud provider's built-in data recovery solution.
Which solution should a data architect use to comply with the DR policy?

Question116: A large Automobile company has implemented SF for its Sales Associates. Leads flow from its website to SF using a batch integration in SF. The Batch job connects the leads to Accounts in SF. Customer visiting their retail stores are also created in SF as Accounts.
The company has noticed a large number of duplicate accounts in SF. On analysis, it was found that certain customers could interact with its website and also visit the store. The Sales associates use Global Search to search for customers in Salesforce before they create the customers.
Which scalable option should a data Architect choose to implement to avoid duplicates?

Question117: Ursa Major Solar's legacy system has a quarterly accounts receivable report that compiles data from the following:
- Accounts
- Contacts
- Opportunities
- Orders
- Order Line Items
Which issue will an architect have when implementing this in Salesforce?

Question118: Universal Containers (UC) loads bulk leads and campaigns from third-party lead aggregators on a weekly and monthly basis. The expected lead record volume is 500K records per week, and the expected campaign records volume is 10K campaigns per week.
After the upload, Lead records are shared with various sales agents via sharing rules and added as Campaign members via Apex triggers on Lead creation. UC agents work on leads for 6 months, but want to keep the records in the system for at least 1 year for reference. Compliance requires them to be stored for a minimum of 3 years. After that, data can be deleted. What statement is true with respect to a data archiving strategy for UC?

Question119: Northern Trail Outfitters has implemented Salesforce for its sales associates nationwide. Senior management is concerned that the executive dashboards are not reliable for their real-time decision-making. On analysis, the team found the following issues with data entered in Salesforce:
1. Information in certain records is incomplete.
2. Incorrect entry in certain fields causes records to be excluded in report filters.
3. Duplicate entries cause incorrect counts.
Which three steps should a data architect recommend to address the issues? (Choose three.)

Question120: Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historically, they have only used
20 Venues. Which two things should the data architect consider when de-normalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers

Question121: Universal Containers (UC) is expecting to have nearly 5 million shipments records in its Salesforce org. Each shipment record has up to 10 child shipment item records. The Shipment custom object has an Organization-wide Default (OWD) sharing model set to Private and the Shipment Item custom object has a Master-Detail relationship to Shipment. There are 25 sharing rules set on the Shipment custom object, which allow shipment records to be shared to each of UC's 25 business areas around the globe. These sharing rules use public groups, one for each business area plus a number of groups for management and support roles. UC has a high turnover of Sales Reps and often needs to move Sales Reps between business areas in order to meet local demand. What feature would ensure that performance, when moving Sales Reps between regions, remains adequate while meeting existing requirements?

Question122: UC has the following system:
Billing system.
Customer support system.
CRM system.
US has been having trouble with business intelligence across the different systems. Recently US implemented a master data management (MDM) solution that will be the system of truth for the customer records.
Which MDM data element is needed to allow reporting across these systems?

Question123: DreamHouse Realty has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout.
DreamHouse Realty has noticed that many of the records coming from the external system are missing data in this field.
The Architect needs to ensure this field always contains data coming from the source system.
Which two approaches should the Architect take? Choose 2 answers

Question124: Universal Containers (UC) is migrating from a legacy system to Salesforce CRM, UC is concerned about the quality of data being entered by users and through external integrations.
Which two solution should a data architect recommend to mitigate data quality issues?

Question125: Universal Containers has a custom object with millions of rows of data.
When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)

Question126: A health care provider wishes to use salesforce to track patient care. The following actions are in Salesforce
1. Payment Providers: Orgas who pay for the care 2 patients.
2. Doctors: They provide care plan for patients and need to support multiple patients, they are provided access to patient information.
3. Patients: They are individuals who need care.
A data architect needs to map the actor to Sf objects. What should be the optimal selection by the data architect?

Question127: Salesforce is being deployed in Ursa Major Solar's disparate, multi-system ERP environment. Ursa major Solar wants to maintain data synchronization between systems.
Which two techniques should be used to achieve this goal? (Choose two.)

Question128: Universal Containers (UC) is planning to launch its Customer Community. The community will allow user to register shipment requests which are then processed by UC employees. Shipment requests contain header information, and then a list of no more than 5 items being shipped. UC will initially roll out its community to
5,000 customers in Europe, and will ultimately roll out to 20,000 customers worldwide within the next two years. UC expects an average of 10 shipment requests per week per customer. UC wants customers to be able to view up to three years of shipment requests and use Saleforce reports. What is the recommended solution for UC's Data Architect to address the requirements?

Question129: Universal Containers (UC) has implemented Sales Cloud for its entire sales organization. UC has built a custom object called Projects_c that stores customer project details and employee billable hours.
The following requirements are needed:
1. A subset of individuals from the finance team will need access to the Projects object for reporting and adjusting employee utilization.
2. The finance users will not need access to any sales objects, but they will need to interact with the custom object.
Which license type should a data architect recommend for the finance team that best meets the requirements?

Question130: Universal Containers (UC) uses the following Salesforce products:
* Sales Cloud for customer management.
* Marketing Cloud for marketing.
* Einstein Analytics for business reporting.
UC occasionally gets a list of prospects from third-party sources as comma-separated values (CSV) files for marketing purposes. Historically, UC would load these contacts into Lead object in Salesforce and sync to Marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud. UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing process.
What should a data architect recommend to UC in order to immediately avoid storage issues in the future?

Question131: Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records.
What should the architect recommend to reduce data load processing time?

Question132: In a Salesforce org used to manage Contacts, what two options should be considered to maintain data quality? Choose 2 answers

Question133: UC is building a salesforce application to track contacts and their respective conferences that they have attended with the following requirements:
1. Contacts will be stored in the standard contact object.
2. Conferences will be stored in a custom conference__c object.
3. Each contact may attend multiple conferences and each conference may be related to multiple contacts.
How should a data architect model the relationship between the contact and conference objects?

Question134: An Architect needs to document the data architecture for a multi-system, enterprise Salesforce implementation.
Which two key artifacts should the Architect use? (Choose two.)

Question135: UC is planning a massive SF implementation with large volumes of dat
a. As part of the org's implementation, several roles, territories, groups, and sharing rules have been configured. The data architect has been tasked with loading all of the required data, including user data, in a timely manner.
What should a data architect do to minimize data load times due to system calculations?

Question136: How can an architect find information about who is creating, changing, or deleting certain fields within the past two months?

Question137: NTO (Northern Trail Outlets) has a complex Salesforce org which has been developed over past 5 years. Internal users are complaining abt multiple data issues, including incomplete and duplicate data in the org. NTO has decided to engage a data architect to analyze and define data quality standards.
Which 3 key factors should a data architect consider while defining data quality standards? Choose 3 answers: